﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 博客评论实体类：blogComment 。
	/// </summary>
	[Serializable]
	public class blogComment
	{
		public blogComment()
		{}

		#region Model
		private int _id; //id
		private string _nickName; //昵称
		private string _email; //邮箱
		private string _url; //网站
		private int _blogid; //文章id
		private string _commentContent; //评论内容
		private DateTime? _pubDate; //发布时间
		private string _pubIp; //发布ip
		private string _agent; //代理信息
		private int _status; //状态
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 昵称
		/// </summary>
		public string nickName
		{
			set{ _nickName=value;}
			get{return _nickName;}
		}
        /// <summary>
		/// 邮箱
		/// </summary>
		public string email
		{
			set{ _email=value;}
			get{return _email;}
		}
        /// <summary>
		/// 网站
		/// </summary>
		public string url
		{
			set{ _url=value;}
			get{return _url;}
		}
        /// <summary>
		/// 文章id
		/// </summary>
		public int blogid
		{
			set{ _blogid=value;}
			get{return _blogid;}
		}
        /// <summary>
		/// 评论内容
		/// </summary>
		public string commentContent
		{
			set{ _commentContent=value;}
			get{return _commentContent;}
		}
        /// <summary>
		/// 发布时间
		/// </summary>
		public DateTime? pubDate
		{
			set{ _pubDate=value;}
			get{return _pubDate;}
		}
        /// <summary>
		/// 发布ip
		/// </summary>
		public string pubIp
		{
			set{ _pubIp=value;}
			get{return _pubIp;}
		}
        /// <summary>
		/// 代理信息
		/// </summary>
		public string agent
		{
			set{ _agent=value;}
			get{return _agent;}
		}
        /// <summary>
		/// 状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
博客评论,blogComment
id,昵称,邮箱,网站,文章id,评论内容,发布时间,发布ip,代理信息,状态,扩展1,扩展2
id,nickName,email,url,blogid,commentContent,pubDate,pubIp,agent,status,ext1,ext2
i,c100,c120,c120,i,t,d,c20,c200,i,c100,c100


--------------------------
-- 创建表[博客评论]开始: 
-- alter table  [BZZ_blogComment] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_blogComment') drop table BZZ_blogComment
  CREATE TABLE [BZZ_blogComment] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [nickName] [varchar] (100),
	 [email] [varchar] (120),
	 [url] [varchar] (120),
	 [blogid] int,
	 [commentContent] [text],
	 [pubDate] [datetime],
	 [pubIp] [varchar] (20),
	 [agent] [varchar] (200),
	 [status] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'博客评论 ',N'user',N'dbo',N'table',N'BZZ_blogComment', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'昵称',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'nickName'
 exec sp_addextendedproperty N'MS_Description',N'邮箱',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'email'
 exec sp_addextendedproperty N'MS_Description',N'网站',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'url'
 exec sp_addextendedproperty N'MS_Description',N'文章id',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'blogid'
 exec sp_addextendedproperty N'MS_Description',N'评论内容',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'commentContent'
 exec sp_addextendedproperty N'MS_Description',N'发布时间',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'pubDate'
 exec sp_addextendedproperty N'MS_Description',N'发布ip',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'pubIp'
 exec sp_addextendedproperty N'MS_Description',N'代理信息',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'agent'
 exec sp_addextendedproperty N'MS_Description',N'状态',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'BZZ_blogComment',N'column',N'ext2'

-- 创建表[博客评论]结束。 
--------------------------

		*/
		#endregion document
	}
}

